Skip to content

Entity Relationship Diagram

DRAFT — Internal Review Only · Not for distribution in wide release

This document is a working draft intended for internal review by the Enterprise OMOP implementation team and our growing network of collaborators. It has not been finalized, peer-reviewed, or approved for external distribution.

See releases and roadmap for details.

The entity relationship diagram visualizes the full NLP infrastructure schema across all four layers — from pipeline registration through _DERIVED CDM tables. It is the companion reference to the Architecture specification.

:material-sitemap-outline: View the ERD

Interactive diagram on Lucidchart — zoom, pan, and comment directly on the schema design.

Open in Lucidchart

Emory login required

The Lucidchart ERD requires an Emory account. Comments and suggestions are welcome directly on the diagram.

The ERD covers:

  • Layer 1 — Process Metadata: nlp_system, pipeline, Component, pipeline_component, nlp_execution, note_span_execution
  • Layer 2 — NLP Output: note_span, note_span_concept, nlp_date, nlp_quantity, note_span_assertion
  • Layer 3 — Intermediate Translation: note_nlp_modifier
  • Layer 4 — _DERIVED Tables: measurement_DERIVED, condition_DERIVED, drug_DERIVED, procedure_DERIVED, observation_DERIVED, death_DERIVED

See Notes and NLP Design for the problem overview and Architecture for the full schema specification.